PostgreSQL Security Management

PostgreSQL manages database access permissions using users and groups. Users own database objects (for example, tables) and can assign privileges on those objects to other users to control who has access to which objects.

Note: Starting from PostgreSQL version 8.1, users and groups were no longer distinct kinds of entities, now there are only roles. Any role can act as a user, a group, or both. The concept of roles subsumes the concepts of users and groups.

Navicat provides User to add, duplicate, edit, delete users/groups/roles, grant/revoke server privileges and privileges on the selected database objects. The object pane displays all the users/groups/roles that exist in the server.

Only a superuser (a user who is allowed all rights) can add/delete users. PostgreSQL installs a single superuser by default named postgres. All other users must be added by this user, or by another subsequently added superuser.

The User for PostgreSQL Server 7.3 to 8.0 and PostgreSQL Server 8.1 to 9.0 are different.

PostgreSQL Server 7.3 to 8.0

Manage User

Just simply click -> User to open an object pane for User. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete users.

Add User

To add a new user

Duplicate User

To create a new user with modification as one of the existing users

Edit User

To edit an existing user

Delete User

To delete a user

Manage Group

Just simply click -> Group to open an object pane for Group. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete groups.

Add Group

To add a new group

Duplicate Group

To create a new group with modification as one of the existing groups

Edit Group

To edit an existing group

Delete Group

To delete a group


PostgreSQL Server 8.1 to 9.0

Just simply click to open an object pane for Role. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete roles.

Add Role

To add a new role

Duplicate Role

To create a new role with modification as one of the existing roles

Edit Role

To edit an existing role

Delete Role

To delete a role

Privilege Manager

To edit privilege according to the database objects by using Privilege Manager